Designing an Excel VBA function to recognize more important irrational numbers

Programming Excel with VBA and .NET - solve real-world problems with Excel

by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...

Assessing Excel VBA Suitability for Monte Carlo Simulation

Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...

Toward Reverse Engineering of VBA Based Excel Spreadsheet Applications

Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult t...

On Irrational and Transcendental Numbers

Unsymmetrical Approximation of Irrational Numbers

1 A 1 < £ < , 5B B SB so that we have the classical theorem of Hurwitz. For other values of r, approximations from both sides are permitted, but the errors allowed on the two sides are different; hence the term unsymmetrical approximation. The result here was new, and is so related to Hurwitz's inequality that one side is strengthened and the other weakened. Notice that the result for r > l is ...